<?php
//require_once '../include/dbcon.php';
function getnewid()
{
	
  $DB_host = "localhost";
$DB_user = "u194461326_chinadmin";
$DB_pass = "China@2023";
$DB_name = "u194461326_chinaschool";

	try
	{
		$DBcon = new PDO("mysql:host={$DB_host};dbname={$DB_name}",$DB_user,$DB_pass);	
		$DBcon->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}
	catch(PDOException $e)
	{
		echo "ERROR : ".$e->getMessage();
	}
$sql = $DBcon->prepare("select sn from members ORDER BY sn DESC LIMIT 1");
$sql->execute() ;
$row = $sql->FETCH(PDO::FETCH_ASSOC) ;
$id = $row['sn'] ;
$newid = $id + 1 ;
$prfix = 'DACE_0' ;
$newuserid = $prfix.$newid ;
//$pwd = $newid.'xchangex' ;
return $newuserid ;
//return $pwd ;	
}


function newregno()
{
	
  $DB_host = "localhost";
$DB_user = "u194461326_chinadmin";
$DB_pass = "China@2023";
$DB_name = "u194461326_chinaschool";

	try
	{
		$DBcon = new PDO("mysql:host={$DB_host};dbname={$DB_name}",$DB_user,$DB_pass);	
		$DBcon->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}
	catch(PDOException $e)
	{
		echo "ERROR : ".$e->getMessage();
	}
$sql = $DBcon->prepare("select sn from students ORDER BY sn DESC LIMIT 1");
$sql->execute() ;
$row = $sql->FETCH(PDO::FETCH_ASSOC) ;
$id = $row['sn'] ;
$newid = $id + 1 ;
$prfix = 'DAC/0' ;
$newuserid = $prfix.$newid ;
//$pwd = $newid.'xchangex' ;
return $newuserid ;
//return $pwd ;	
}

?>